<html><head><title>ANSI_join</title><meta name="HandheldFriendly" content="True"></head><body>Detailed syntax:<br><br><a href="q307691.html">table_reference</a> {<b>inner</b> | <b>left</b> [<b>outer</b>] | <b>right</b> | [<b>outer</b>]} <b>join</b> <a href="q307691.html">table_reference</a> <b>on</b> search_conditions</body></html>